package trlygjj.tanruiliyigenjinjin.mapper;

import trlygjj.tanruiliyigenjinjin.domain.DataDictionary;
import trlygjj.tanruiliyigenjinjin.query.QueryObject;

import java.util.List;

public interface DataDictionaryMapper {
    int deleteByPrimaryKey(Long id);

    int insert(DataDictionary record);

    DataDictionary selectByPrimaryKey(Long id);

    List<DataDictionary> selectAll();

    int updateByPrimaryKey(DataDictionary record);

    int queryForCount(QueryObject qo);

    List<DataDictionary> queryForList(QueryObject qo);

    /**
     * 获取大客户的重要程度
     * @param sn
     * @return
     */
    List<DataDictionary> getImportantBySn(DataDictionary sn);

    /**
     * 获取大客户的意向程度
     * @param sn
     * @return
     */
    List<DataDictionary> getIntentionBySn(DataDictionary sn);

    /**
     * 获取大客户的意向学科
     * @param sn
     * @return
     */
    List<DataDictionary> getIntentionSubjectBySn(DataDictionary sn);

    /**
     * 获取大客户的意向校区
     * @param sn
     * @return
     */
    List<DataDictionary> getIntentionDistrictBySn(DataDictionary sn);

    /**
     * 获取大客户的规定学历
     * @param sn
     * @return
     */
    List<DataDictionary> getEducationBySn(DataDictionary sn);

    /**
     * 获取大客户的学校体制
     * @param sn
     * @return
     */
    List<DataDictionary> getSchoolSystemBySn(DataDictionary sn);

    DataDictionary selectDataDictionaryItemsBySn(String sn);
}